home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
close_batch.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
804b
|
20 lines
/* RCSVER $Id: close_batch.sql,v 1.1 1999-12-02 16:51:22-06 randy CURRENT $ */
/* *************************************************************************
* Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
*
* Name: close_batch
* Date: 08/18/1999
* memo: Randy Wood
* Description: Create the close_batch table.This table contains
* general information concerning a set of closed matches.
* Changes:
************************************************************************* */
CREATE TABLE close_batch
(
clbatch_num NUMBER(38), /* Batch number for this closing */
user_name VARCHAR2(50), /* CHC user performing the close */
close_date DATE, /* Date of closing */
comments VARCHAR2(500), /* Comments */
CONSTRAINT pk_closebatch PRIMARY KEY (clbatch_num)
);